package com.crm.model.entity.returnMoney;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class ReturnMoneyExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ReturnMoneyExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andReturnMoneyIdIsNull() {
            addCriterion("return_money_id is null");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdIsNotNull() {
            addCriterion("return_money_id is not null");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdEqualTo(String value) {
            addCriterion("return_money_id =", value, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdNotEqualTo(String value) {
            addCriterion("return_money_id <>", value, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdGreaterThan(String value) {
            addCriterion("return_money_id >", value, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdGreaterThanOrEqualTo(String value) {
            addCriterion("return_money_id >=", value, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdLessThan(String value) {
            addCriterion("return_money_id <", value, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdLessThanOrEqualTo(String value) {
            addCriterion("return_money_id <=", value, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdLike(String value) {
            addCriterion("return_money_id like", value, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdNotLike(String value) {
            addCriterion("return_money_id not like", value, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdIn(List<String> values) {
            addCriterion("return_money_id in", values, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdNotIn(List<String> values) {
            addCriterion("return_money_id not in", values, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdBetween(String value1, String value2) {
            addCriterion("return_money_id between", value1, value2, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andReturnMoneyIdNotBetween(String value1, String value2) {
            addCriterion("return_money_id not between", value1, value2, "returnMoneyId");
            return (Criteria) this;
        }

        public Criteria andSerialIsNull() {
            addCriterion("serial is null");
            return (Criteria) this;
        }

        public Criteria andSerialIsNotNull() {
            addCriterion("serial is not null");
            return (Criteria) this;
        }

        public Criteria andSerialEqualTo(String value) {
            addCriterion("serial =", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialNotEqualTo(String value) {
            addCriterion("serial <>", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialGreaterThan(String value) {
            addCriterion("serial >", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialGreaterThanOrEqualTo(String value) {
            addCriterion("serial >=", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialLessThan(String value) {
            addCriterion("serial <", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialLessThanOrEqualTo(String value) {
            addCriterion("serial <=", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialLike(String value) {
            addCriterion("serial like", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialNotLike(String value) {
            addCriterion("serial not like", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialIn(List<String> values) {
            addCriterion("serial in", values, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialNotIn(List<String> values) {
            addCriterion("serial not in", values, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialBetween(String value1, String value2) {
            addCriterion("serial between", value1, value2, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialNotBetween(String value1, String value2) {
            addCriterion("serial not between", value1, value2, "serial");
            return (Criteria) this;
        }

        public Criteria andArriveTimeIsNull() {
            addCriterion("arrive_time is null");
            return (Criteria) this;
        }

        public Criteria andArriveTimeIsNotNull() {
            addCriterion("arrive_time is not null");
            return (Criteria) this;
        }

        public Criteria andArriveTimeEqualTo(Date value) {
            addCriterion("arrive_time =", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeNotEqualTo(Date value) {
            addCriterion("arrive_time <>", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeGreaterThan(Date value) {
            addCriterion("arrive_time >", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("arrive_time >=", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeLessThan(Date value) {
            addCriterion("arrive_time <", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeLessThanOrEqualTo(Date value) {
            addCriterion("arrive_time <=", value, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeIn(List<Date> values) {
            addCriterion("arrive_time in", values, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeNotIn(List<Date> values) {
            addCriterion("arrive_time not in", values, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeBetween(Date value1, Date value2) {
            addCriterion("arrive_time between", value1, value2, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveTimeNotBetween(Date value1, Date value2) {
            addCriterion("arrive_time not between", value1, value2, "arriveTime");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyIsNull() {
            addCriterion("arrive_money is null");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyIsNotNull() {
            addCriterion("arrive_money is not null");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyEqualTo(BigDecimal value) {
            addCriterion("arrive_money =", value, "arriveMoney");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyNotEqualTo(BigDecimal value) {
            addCriterion("arrive_money <>", value, "arriveMoney");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyGreaterThan(BigDecimal value) {
            addCriterion("arrive_money >", value, "arriveMoney");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("arrive_money >=", value, "arriveMoney");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyLessThan(BigDecimal value) {
            addCriterion("arrive_money <", value, "arriveMoney");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("arrive_money <=", value, "arriveMoney");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyIn(List<BigDecimal> values) {
            addCriterion("arrive_money in", values, "arriveMoney");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyNotIn(List<BigDecimal> values) {
            addCriterion("arrive_money not in", values, "arriveMoney");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("arrive_money between", value1, value2, "arriveMoney");
            return (Criteria) this;
        }

        public Criteria andArriveMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("arrive_money not between", value1, value2, "arriveMoney");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameIsNull() {
            addCriterion("arrive_unit_name is null");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameIsNotNull() {
            addCriterion("arrive_unit_name is not null");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameEqualTo(String value) {
            addCriterion("arrive_unit_name =", value, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameNotEqualTo(String value) {
            addCriterion("arrive_unit_name <>", value, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameGreaterThan(String value) {
            addCriterion("arrive_unit_name >", value, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameGreaterThanOrEqualTo(String value) {
            addCriterion("arrive_unit_name >=", value, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameLessThan(String value) {
            addCriterion("arrive_unit_name <", value, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameLessThanOrEqualTo(String value) {
            addCriterion("arrive_unit_name <=", value, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameLike(String value) {
            addCriterion("arrive_unit_name like", value, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameNotLike(String value) {
            addCriterion("arrive_unit_name not like", value, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameIn(List<String> values) {
            addCriterion("arrive_unit_name in", values, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameNotIn(List<String> values) {
            addCriterion("arrive_unit_name not in", values, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameBetween(String value1, String value2) {
            addCriterion("arrive_unit_name between", value1, value2, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveUnitNameNotBetween(String value1, String value2) {
            addCriterion("arrive_unit_name not between", value1, value2, "arriveUnitName");
            return (Criteria) this;
        }

        public Criteria andArriveTypeIsNull() {
            addCriterion("arrive_type is null");
            return (Criteria) this;
        }

        public Criteria andArriveTypeIsNotNull() {
            addCriterion("arrive_type is not null");
            return (Criteria) this;
        }

        public Criteria andArriveTypeEqualTo(Integer value) {
            addCriterion("arrive_type =", value, "arriveType");
            return (Criteria) this;
        }

        public Criteria andArriveTypeNotEqualTo(Integer value) {
            addCriterion("arrive_type <>", value, "arriveType");
            return (Criteria) this;
        }

        public Criteria andArriveTypeGreaterThan(Integer value) {
            addCriterion("arrive_type >", value, "arriveType");
            return (Criteria) this;
        }

        public Criteria andArriveTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("arrive_type >=", value, "arriveType");
            return (Criteria) this;
        }

        public Criteria andArriveTypeLessThan(Integer value) {
            addCriterion("arrive_type <", value, "arriveType");
            return (Criteria) this;
        }

        public Criteria andArriveTypeLessThanOrEqualTo(Integer value) {
            addCriterion("arrive_type <=", value, "arriveType");
            return (Criteria) this;
        }

        public Criteria andArriveTypeIn(List<Integer> values) {
            addCriterion("arrive_type in", values, "arriveType");
            return (Criteria) this;
        }

        public Criteria andArriveTypeNotIn(List<Integer> values) {
            addCriterion("arrive_type not in", values, "arriveType");
            return (Criteria) this;
        }

        public Criteria andArriveTypeBetween(Integer value1, Integer value2) {
            addCriterion("arrive_type between", value1, value2, "arriveType");
            return (Criteria) this;
        }

        public Criteria andArriveTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("arrive_type not between", value1, value2, "arriveType");
            return (Criteria) this;
        }

        public Criteria andArriveNumIsNull() {
            addCriterion("arrive_num is null");
            return (Criteria) this;
        }

        public Criteria andArriveNumIsNotNull() {
            addCriterion("arrive_num is not null");
            return (Criteria) this;
        }

        public Criteria andArriveNumEqualTo(String value) {
            addCriterion("arrive_num =", value, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumNotEqualTo(String value) {
            addCriterion("arrive_num <>", value, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumGreaterThan(String value) {
            addCriterion("arrive_num >", value, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumGreaterThanOrEqualTo(String value) {
            addCriterion("arrive_num >=", value, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumLessThan(String value) {
            addCriterion("arrive_num <", value, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumLessThanOrEqualTo(String value) {
            addCriterion("arrive_num <=", value, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumLike(String value) {
            addCriterion("arrive_num like", value, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumNotLike(String value) {
            addCriterion("arrive_num not like", value, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumIn(List<String> values) {
            addCriterion("arrive_num in", values, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumNotIn(List<String> values) {
            addCriterion("arrive_num not in", values, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumBetween(String value1, String value2) {
            addCriterion("arrive_num between", value1, value2, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveNumNotBetween(String value1, String value2) {
            addCriterion("arrive_num not between", value1, value2, "arriveNum");
            return (Criteria) this;
        }

        public Criteria andArriveMethodIsNull() {
            addCriterion("arrive_method is null");
            return (Criteria) this;
        }

        public Criteria andArriveMethodIsNotNull() {
            addCriterion("arrive_method is not null");
            return (Criteria) this;
        }

        public Criteria andArriveMethodEqualTo(Integer value) {
            addCriterion("arrive_method =", value, "arriveMethod");
            return (Criteria) this;
        }

        public Criteria andArriveMethodNotEqualTo(Integer value) {
            addCriterion("arrive_method <>", value, "arriveMethod");
            return (Criteria) this;
        }

        public Criteria andArriveMethodGreaterThan(Integer value) {
            addCriterion("arrive_method >", value, "arriveMethod");
            return (Criteria) this;
        }

        public Criteria andArriveMethodGreaterThanOrEqualTo(Integer value) {
            addCriterion("arrive_method >=", value, "arriveMethod");
            return (Criteria) this;
        }

        public Criteria andArriveMethodLessThan(Integer value) {
            addCriterion("arrive_method <", value, "arriveMethod");
            return (Criteria) this;
        }

        public Criteria andArriveMethodLessThanOrEqualTo(Integer value) {
            addCriterion("arrive_method <=", value, "arriveMethod");
            return (Criteria) this;
        }

        public Criteria andArriveMethodIn(List<Integer> values) {
            addCriterion("arrive_method in", values, "arriveMethod");
            return (Criteria) this;
        }

        public Criteria andArriveMethodNotIn(List<Integer> values) {
            addCriterion("arrive_method not in", values, "arriveMethod");
            return (Criteria) this;
        }

        public Criteria andArriveMethodBetween(Integer value1, Integer value2) {
            addCriterion("arrive_method between", value1, value2, "arriveMethod");
            return (Criteria) this;
        }

        public Criteria andArriveMethodNotBetween(Integer value1, Integer value2) {
            addCriterion("arrive_method not between", value1, value2, "arriveMethod");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishIsNull() {
            addCriterion("arrive_is_abolish is null");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishIsNotNull() {
            addCriterion("arrive_is_abolish is not null");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishEqualTo(Integer value) {
            addCriterion("arrive_is_abolish =", value, "arriveIsAbolish");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishNotEqualTo(Integer value) {
            addCriterion("arrive_is_abolish <>", value, "arriveIsAbolish");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishGreaterThan(Integer value) {
            addCriterion("arrive_is_abolish >", value, "arriveIsAbolish");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishGreaterThanOrEqualTo(Integer value) {
            addCriterion("arrive_is_abolish >=", value, "arriveIsAbolish");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishLessThan(Integer value) {
            addCriterion("arrive_is_abolish <", value, "arriveIsAbolish");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishLessThanOrEqualTo(Integer value) {
            addCriterion("arrive_is_abolish <=", value, "arriveIsAbolish");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishIn(List<Integer> values) {
            addCriterion("arrive_is_abolish in", values, "arriveIsAbolish");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishNotIn(List<Integer> values) {
            addCriterion("arrive_is_abolish not in", values, "arriveIsAbolish");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishBetween(Integer value1, Integer value2) {
            addCriterion("arrive_is_abolish between", value1, value2, "arriveIsAbolish");
            return (Criteria) this;
        }

        public Criteria andArriveIsAbolishNotBetween(Integer value1, Integer value2) {
            addCriterion("arrive_is_abolish not between", value1, value2, "arriveIsAbolish");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeIsNull() {
            addCriterion("arrive_account_type is null");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeIsNotNull() {
            addCriterion("arrive_account_type is not null");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeEqualTo(Integer value) {
            addCriterion("arrive_account_type =", value, "arriveAccountType");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeNotEqualTo(Integer value) {
            addCriterion("arrive_account_type <>", value, "arriveAccountType");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeGreaterThan(Integer value) {
            addCriterion("arrive_account_type >", value, "arriveAccountType");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("arrive_account_type >=", value, "arriveAccountType");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeLessThan(Integer value) {
            addCriterion("arrive_account_type <", value, "arriveAccountType");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeLessThanOrEqualTo(Integer value) {
            addCriterion("arrive_account_type <=", value, "arriveAccountType");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeIn(List<Integer> values) {
            addCriterion("arrive_account_type in", values, "arriveAccountType");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeNotIn(List<Integer> values) {
            addCriterion("arrive_account_type not in", values, "arriveAccountType");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeBetween(Integer value1, Integer value2) {
            addCriterion("arrive_account_type between", value1, value2, "arriveAccountType");
            return (Criteria) this;
        }

        public Criteria andArriveAccountTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("arrive_account_type not between", value1, value2, "arriveAccountType");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitIsNull() {
            addCriterion("payment_unit is null");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitIsNotNull() {
            addCriterion("payment_unit is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitEqualTo(String value) {
            addCriterion("payment_unit =", value, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitNotEqualTo(String value) {
            addCriterion("payment_unit <>", value, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitGreaterThan(String value) {
            addCriterion("payment_unit >", value, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitGreaterThanOrEqualTo(String value) {
            addCriterion("payment_unit >=", value, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitLessThan(String value) {
            addCriterion("payment_unit <", value, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitLessThanOrEqualTo(String value) {
            addCriterion("payment_unit <=", value, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitLike(String value) {
            addCriterion("payment_unit like", value, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitNotLike(String value) {
            addCriterion("payment_unit not like", value, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitIn(List<String> values) {
            addCriterion("payment_unit in", values, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitNotIn(List<String> values) {
            addCriterion("payment_unit not in", values, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitBetween(String value1, String value2) {
            addCriterion("payment_unit between", value1, value2, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentUnitNotBetween(String value1, String value2) {
            addCriterion("payment_unit not between", value1, value2, "paymentUnit");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountIsNull() {
            addCriterion("payment_account is null");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountIsNotNull() {
            addCriterion("payment_account is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountEqualTo(String value) {
            addCriterion("payment_account =", value, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountNotEqualTo(String value) {
            addCriterion("payment_account <>", value, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountGreaterThan(String value) {
            addCriterion("payment_account >", value, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountGreaterThanOrEqualTo(String value) {
            addCriterion("payment_account >=", value, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountLessThan(String value) {
            addCriterion("payment_account <", value, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountLessThanOrEqualTo(String value) {
            addCriterion("payment_account <=", value, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountLike(String value) {
            addCriterion("payment_account like", value, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountNotLike(String value) {
            addCriterion("payment_account not like", value, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountIn(List<String> values) {
            addCriterion("payment_account in", values, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountNotIn(List<String> values) {
            addCriterion("payment_account not in", values, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountBetween(String value1, String value2) {
            addCriterion("payment_account between", value1, value2, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentAccountNotBetween(String value1, String value2) {
            addCriterion("payment_account not between", value1, value2, "paymentAccount");
            return (Criteria) this;
        }

        public Criteria andPaymentBankIsNull() {
            addCriterion("payment_bank is null");
            return (Criteria) this;
        }

        public Criteria andPaymentBankIsNotNull() {
            addCriterion("payment_bank is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentBankEqualTo(String value) {
            addCriterion("payment_bank =", value, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankNotEqualTo(String value) {
            addCriterion("payment_bank <>", value, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankGreaterThan(String value) {
            addCriterion("payment_bank >", value, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankGreaterThanOrEqualTo(String value) {
            addCriterion("payment_bank >=", value, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankLessThan(String value) {
            addCriterion("payment_bank <", value, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankLessThanOrEqualTo(String value) {
            addCriterion("payment_bank <=", value, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankLike(String value) {
            addCriterion("payment_bank like", value, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankNotLike(String value) {
            addCriterion("payment_bank not like", value, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankIn(List<String> values) {
            addCriterion("payment_bank in", values, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankNotIn(List<String> values) {
            addCriterion("payment_bank not in", values, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankBetween(String value1, String value2) {
            addCriterion("payment_bank between", value1, value2, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andPaymentBankNotBetween(String value1, String value2) {
            addCriterion("payment_bank not between", value1, value2, "paymentBank");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNull() {
            addCriterion("product_id is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("product_id is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(String value) {
            addCriterion("product_id =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(String value) {
            addCriterion("product_id <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(String value) {
            addCriterion("product_id >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(String value) {
            addCriterion("product_id >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(String value) {
            addCriterion("product_id <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(String value) {
            addCriterion("product_id <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLike(String value) {
            addCriterion("product_id like", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotLike(String value) {
            addCriterion("product_id not like", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<String> values) {
            addCriterion("product_id in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<String> values) {
            addCriterion("product_id not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(String value1, String value2) {
            addCriterion("product_id between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(String value1, String value2) {
            addCriterion("product_id not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductNumberIsNull() {
            addCriterion("product_number is null");
            return (Criteria) this;
        }

        public Criteria andProductNumberIsNotNull() {
            addCriterion("product_number is not null");
            return (Criteria) this;
        }

        public Criteria andProductNumberEqualTo(String value) {
            addCriterion("product_number =", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberNotEqualTo(String value) {
            addCriterion("product_number <>", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberGreaterThan(String value) {
            addCriterion("product_number >", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberGreaterThanOrEqualTo(String value) {
            addCriterion("product_number >=", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberLessThan(String value) {
            addCriterion("product_number <", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberLessThanOrEqualTo(String value) {
            addCriterion("product_number <=", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberLike(String value) {
            addCriterion("product_number like", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberNotLike(String value) {
            addCriterion("product_number not like", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberIn(List<String> values) {
            addCriterion("product_number in", values, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberNotIn(List<String> values) {
            addCriterion("product_number not in", values, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberBetween(String value1, String value2) {
            addCriterion("product_number between", value1, value2, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberNotBetween(String value1, String value2) {
            addCriterion("product_number not between", value1, value2, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNameIsNull() {
            addCriterion("product_name is null");
            return (Criteria) this;
        }

        public Criteria andProductNameIsNotNull() {
            addCriterion("product_name is not null");
            return (Criteria) this;
        }

        public Criteria andProductNameEqualTo(String value) {
            addCriterion("product_name =", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotEqualTo(String value) {
            addCriterion("product_name <>", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThan(String value) {
            addCriterion("product_name >", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThanOrEqualTo(String value) {
            addCriterion("product_name >=", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLessThan(String value) {
            addCriterion("product_name <", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLessThanOrEqualTo(String value) {
            addCriterion("product_name <=", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLike(String value) {
            addCriterion("product_name like", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotLike(String value) {
            addCriterion("product_name not like", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameIn(List<String> values) {
            addCriterion("product_name in", values, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotIn(List<String> values) {
            addCriterion("product_name not in", values, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameBetween(String value1, String value2) {
            addCriterion("product_name between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotBetween(String value1, String value2) {
            addCriterion("product_name not between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesIsNull() {
            addCriterion("product_categories is null");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesIsNotNull() {
            addCriterion("product_categories is not null");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesEqualTo(String value) {
            addCriterion("product_categories =", value, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesNotEqualTo(String value) {
            addCriterion("product_categories <>", value, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesGreaterThan(String value) {
            addCriterion("product_categories >", value, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesGreaterThanOrEqualTo(String value) {
            addCriterion("product_categories >=", value, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesLessThan(String value) {
            addCriterion("product_categories <", value, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesLessThanOrEqualTo(String value) {
            addCriterion("product_categories <=", value, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesLike(String value) {
            addCriterion("product_categories like", value, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesNotLike(String value) {
            addCriterion("product_categories not like", value, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesIn(List<String> values) {
            addCriterion("product_categories in", values, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesNotIn(List<String> values) {
            addCriterion("product_categories not in", values, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesBetween(String value1, String value2) {
            addCriterion("product_categories between", value1, value2, "productCategories");
            return (Criteria) this;
        }

        public Criteria andProductCategoriesNotBetween(String value1, String value2) {
            addCriterion("product_categories not between", value1, value2, "productCategories");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdIsNull() {
            addCriterion("finish_order_product_id is null");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdIsNotNull() {
            addCriterion("finish_order_product_id is not null");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdEqualTo(String value) {
            addCriterion("finish_order_product_id =", value, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdNotEqualTo(String value) {
            addCriterion("finish_order_product_id <>", value, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdGreaterThan(String value) {
            addCriterion("finish_order_product_id >", value, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdGreaterThanOrEqualTo(String value) {
            addCriterion("finish_order_product_id >=", value, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdLessThan(String value) {
            addCriterion("finish_order_product_id <", value, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdLessThanOrEqualTo(String value) {
            addCriterion("finish_order_product_id <=", value, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdLike(String value) {
            addCriterion("finish_order_product_id like", value, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdNotLike(String value) {
            addCriterion("finish_order_product_id not like", value, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdIn(List<String> values) {
            addCriterion("finish_order_product_id in", values, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdNotIn(List<String> values) {
            addCriterion("finish_order_product_id not in", values, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdBetween(String value1, String value2) {
            addCriterion("finish_order_product_id between", value1, value2, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductIdNotBetween(String value1, String value2) {
            addCriterion("finish_order_product_id not between", value1, value2, "finishOrderProductId");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumIsNull() {
            addCriterion("finish_order_product_num is null");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumIsNotNull() {
            addCriterion("finish_order_product_num is not null");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumEqualTo(String value) {
            addCriterion("finish_order_product_num =", value, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumNotEqualTo(String value) {
            addCriterion("finish_order_product_num <>", value, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumGreaterThan(String value) {
            addCriterion("finish_order_product_num >", value, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumGreaterThanOrEqualTo(String value) {
            addCriterion("finish_order_product_num >=", value, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumLessThan(String value) {
            addCriterion("finish_order_product_num <", value, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumLessThanOrEqualTo(String value) {
            addCriterion("finish_order_product_num <=", value, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumLike(String value) {
            addCriterion("finish_order_product_num like", value, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumNotLike(String value) {
            addCriterion("finish_order_product_num not like", value, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumIn(List<String> values) {
            addCriterion("finish_order_product_num in", values, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumNotIn(List<String> values) {
            addCriterion("finish_order_product_num not in", values, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumBetween(String value1, String value2) {
            addCriterion("finish_order_product_num between", value1, value2, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andFinishOrderProductNumNotBetween(String value1, String value2) {
            addCriterion("finish_order_product_num not between", value1, value2, "finishOrderProductNum");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeIsNull() {
            addCriterion("order_detail_type is null");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeIsNotNull() {
            addCriterion("order_detail_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeEqualTo(String value) {
            addCriterion("order_detail_type =", value, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeNotEqualTo(String value) {
            addCriterion("order_detail_type <>", value, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeGreaterThan(String value) {
            addCriterion("order_detail_type >", value, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeGreaterThanOrEqualTo(String value) {
            addCriterion("order_detail_type >=", value, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeLessThan(String value) {
            addCriterion("order_detail_type <", value, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeLessThanOrEqualTo(String value) {
            addCriterion("order_detail_type <=", value, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeLike(String value) {
            addCriterion("order_detail_type like", value, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeNotLike(String value) {
            addCriterion("order_detail_type not like", value, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeIn(List<String> values) {
            addCriterion("order_detail_type in", values, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeNotIn(List<String> values) {
            addCriterion("order_detail_type not in", values, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeBetween(String value1, String value2) {
            addCriterion("order_detail_type between", value1, value2, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andOrderDetailTypeNotBetween(String value1, String value2) {
            addCriterion("order_detail_type not between", value1, value2, "orderDetailType");
            return (Criteria) this;
        }

        public Criteria andContractStatusIsNull() {
            addCriterion("contract_status is null");
            return (Criteria) this;
        }

        public Criteria andContractStatusIsNotNull() {
            addCriterion("contract_status is not null");
            return (Criteria) this;
        }

        public Criteria andContractStatusEqualTo(Integer value) {
            addCriterion("contract_status =", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotEqualTo(Integer value) {
            addCriterion("contract_status <>", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusGreaterThan(Integer value) {
            addCriterion("contract_status >", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("contract_status >=", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusLessThan(Integer value) {
            addCriterion("contract_status <", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusLessThanOrEqualTo(Integer value) {
            addCriterion("contract_status <=", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusIn(List<Integer> values) {
            addCriterion("contract_status in", values, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotIn(List<Integer> values) {
            addCriterion("contract_status not in", values, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusBetween(Integer value1, Integer value2) {
            addCriterion("contract_status between", value1, value2, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("contract_status not between", value1, value2, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractTypeIsNull() {
            addCriterion("contract_type is null");
            return (Criteria) this;
        }

        public Criteria andContractTypeIsNotNull() {
            addCriterion("contract_type is not null");
            return (Criteria) this;
        }

        public Criteria andContractTypeEqualTo(String value) {
            addCriterion("contract_type =", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotEqualTo(String value) {
            addCriterion("contract_type <>", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeGreaterThan(String value) {
            addCriterion("contract_type >", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeGreaterThanOrEqualTo(String value) {
            addCriterion("contract_type >=", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLessThan(String value) {
            addCriterion("contract_type <", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLessThanOrEqualTo(String value) {
            addCriterion("contract_type <=", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLike(String value) {
            addCriterion("contract_type like", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotLike(String value) {
            addCriterion("contract_type not like", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeIn(List<String> values) {
            addCriterion("contract_type in", values, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotIn(List<String> values) {
            addCriterion("contract_type not in", values, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeBetween(String value1, String value2) {
            addCriterion("contract_type between", value1, value2, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotBetween(String value1, String value2) {
            addCriterion("contract_type not between", value1, value2, "contractType");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeIsNull() {
            addCriterion("renew_contract_start_time is null");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeIsNotNull() {
            addCriterion("renew_contract_start_time is not null");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeEqualTo(Date value) {
            addCriterionForJDBCDate("renew_contract_start_time =", value, "renewContractStartTime");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("renew_contract_start_time <>", value, "renewContractStartTime");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeGreaterThan(Date value) {
            addCriterionForJDBCDate("renew_contract_start_time >", value, "renewContractStartTime");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("renew_contract_start_time >=", value, "renewContractStartTime");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeLessThan(Date value) {
            addCriterionForJDBCDate("renew_contract_start_time <", value, "renewContractStartTime");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("renew_contract_start_time <=", value, "renewContractStartTime");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeIn(List<Date> values) {
            addCriterionForJDBCDate("renew_contract_start_time in", values, "renewContractStartTime");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("renew_contract_start_time not in", values, "renewContractStartTime");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("renew_contract_start_time between", value1, value2, "renewContractStartTime");
            return (Criteria) this;
        }

        public Criteria andRenewContractStartTimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("renew_contract_start_time not between", value1, value2, "renewContractStartTime");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioIsNull() {
            addCriterion("score_convert_ratio is null");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioIsNotNull() {
            addCriterion("score_convert_ratio is not null");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioEqualTo(BigDecimal value) {
            addCriterion("score_convert_ratio =", value, "scoreConvertRatio");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioNotEqualTo(BigDecimal value) {
            addCriterion("score_convert_ratio <>", value, "scoreConvertRatio");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioGreaterThan(BigDecimal value) {
            addCriterion("score_convert_ratio >", value, "scoreConvertRatio");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("score_convert_ratio >=", value, "scoreConvertRatio");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioLessThan(BigDecimal value) {
            addCriterion("score_convert_ratio <", value, "scoreConvertRatio");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioLessThanOrEqualTo(BigDecimal value) {
            addCriterion("score_convert_ratio <=", value, "scoreConvertRatio");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioIn(List<BigDecimal> values) {
            addCriterion("score_convert_ratio in", values, "scoreConvertRatio");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioNotIn(List<BigDecimal> values) {
            addCriterion("score_convert_ratio not in", values, "scoreConvertRatio");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("score_convert_ratio between", value1, value2, "scoreConvertRatio");
            return (Criteria) this;
        }

        public Criteria andScoreConvertRatioNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("score_convert_ratio not between", value1, value2, "scoreConvertRatio");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyIsNull() {
            addCriterion("score_money is null");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyIsNotNull() {
            addCriterion("score_money is not null");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyEqualTo(BigDecimal value) {
            addCriterion("score_money =", value, "scoreMoney");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyNotEqualTo(BigDecimal value) {
            addCriterion("score_money <>", value, "scoreMoney");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyGreaterThan(BigDecimal value) {
            addCriterion("score_money >", value, "scoreMoney");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("score_money >=", value, "scoreMoney");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyLessThan(BigDecimal value) {
            addCriterion("score_money <", value, "scoreMoney");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("score_money <=", value, "scoreMoney");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyIn(List<BigDecimal> values) {
            addCriterion("score_money in", values, "scoreMoney");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyNotIn(List<BigDecimal> values) {
            addCriterion("score_money not in", values, "scoreMoney");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("score_money between", value1, value2, "scoreMoney");
            return (Criteria) this;
        }

        public Criteria andScoreMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("score_money not between", value1, value2, "scoreMoney");
            return (Criteria) this;
        }

        public Criteria andVipTypeIsNull() {
            addCriterion("vip_type is null");
            return (Criteria) this;
        }

        public Criteria andVipTypeIsNotNull() {
            addCriterion("vip_type is not null");
            return (Criteria) this;
        }

        public Criteria andVipTypeEqualTo(Integer value) {
            addCriterion("vip_type =", value, "vipType");
            return (Criteria) this;
        }

        public Criteria andVipTypeNotEqualTo(Integer value) {
            addCriterion("vip_type <>", value, "vipType");
            return (Criteria) this;
        }

        public Criteria andVipTypeGreaterThan(Integer value) {
            addCriterion("vip_type >", value, "vipType");
            return (Criteria) this;
        }

        public Criteria andVipTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("vip_type >=", value, "vipType");
            return (Criteria) this;
        }

        public Criteria andVipTypeLessThan(Integer value) {
            addCriterion("vip_type <", value, "vipType");
            return (Criteria) this;
        }

        public Criteria andVipTypeLessThanOrEqualTo(Integer value) {
            addCriterion("vip_type <=", value, "vipType");
            return (Criteria) this;
        }

        public Criteria andVipTypeIn(List<Integer> values) {
            addCriterion("vip_type in", values, "vipType");
            return (Criteria) this;
        }

        public Criteria andVipTypeNotIn(List<Integer> values) {
            addCriterion("vip_type not in", values, "vipType");
            return (Criteria) this;
        }

        public Criteria andVipTypeBetween(Integer value1, Integer value2) {
            addCriterion("vip_type between", value1, value2, "vipType");
            return (Criteria) this;
        }

        public Criteria andVipTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("vip_type not between", value1, value2, "vipType");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreIsNull() {
            addCriterion("is_record_score is null");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreIsNotNull() {
            addCriterion("is_record_score is not null");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreEqualTo(Integer value) {
            addCriterion("is_record_score =", value, "isRecordScore");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreNotEqualTo(Integer value) {
            addCriterion("is_record_score <>", value, "isRecordScore");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreGreaterThan(Integer value) {
            addCriterion("is_record_score >", value, "isRecordScore");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_record_score >=", value, "isRecordScore");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreLessThan(Integer value) {
            addCriterion("is_record_score <", value, "isRecordScore");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreLessThanOrEqualTo(Integer value) {
            addCriterion("is_record_score <=", value, "isRecordScore");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreIn(List<Integer> values) {
            addCriterion("is_record_score in", values, "isRecordScore");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreNotIn(List<Integer> values) {
            addCriterion("is_record_score not in", values, "isRecordScore");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreBetween(Integer value1, Integer value2) {
            addCriterion("is_record_score between", value1, value2, "isRecordScore");
            return (Criteria) this;
        }

        public Criteria andIsRecordScoreNotBetween(Integer value1, Integer value2) {
            addCriterion("is_record_score not between", value1, value2, "isRecordScore");
            return (Criteria) this;
        }

        public Criteria andIsBackIsNull() {
            addCriterion("is_back is null");
            return (Criteria) this;
        }

        public Criteria andIsBackIsNotNull() {
            addCriterion("is_back is not null");
            return (Criteria) this;
        }

        public Criteria andIsBackEqualTo(Integer value) {
            addCriterion("is_back =", value, "isBack");
            return (Criteria) this;
        }

        public Criteria andIsBackNotEqualTo(Integer value) {
            addCriterion("is_back <>", value, "isBack");
            return (Criteria) this;
        }

        public Criteria andIsBackGreaterThan(Integer value) {
            addCriterion("is_back >", value, "isBack");
            return (Criteria) this;
        }

        public Criteria andIsBackGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_back >=", value, "isBack");
            return (Criteria) this;
        }

        public Criteria andIsBackLessThan(Integer value) {
            addCriterion("is_back <", value, "isBack");
            return (Criteria) this;
        }

        public Criteria andIsBackLessThanOrEqualTo(Integer value) {
            addCriterion("is_back <=", value, "isBack");
            return (Criteria) this;
        }

        public Criteria andIsBackIn(List<Integer> values) {
            addCriterion("is_back in", values, "isBack");
            return (Criteria) this;
        }

        public Criteria andIsBackNotIn(List<Integer> values) {
            addCriterion("is_back not in", values, "isBack");
            return (Criteria) this;
        }

        public Criteria andIsBackBetween(Integer value1, Integer value2) {
            addCriterion("is_back between", value1, value2, "isBack");
            return (Criteria) this;
        }

        public Criteria andIsBackNotBetween(Integer value1, Integer value2) {
            addCriterion("is_back not between", value1, value2, "isBack");
            return (Criteria) this;
        }

        public Criteria andBackDateIsNull() {
            addCriterion("back_date is null");
            return (Criteria) this;
        }

        public Criteria andBackDateIsNotNull() {
            addCriterion("back_date is not null");
            return (Criteria) this;
        }

        public Criteria andBackDateEqualTo(Date value) {
            addCriterionForJDBCDate("back_date =", value, "backDate");
            return (Criteria) this;
        }

        public Criteria andBackDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("back_date <>", value, "backDate");
            return (Criteria) this;
        }

        public Criteria andBackDateGreaterThan(Date value) {
            addCriterionForJDBCDate("back_date >", value, "backDate");
            return (Criteria) this;
        }

        public Criteria andBackDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("back_date >=", value, "backDate");
            return (Criteria) this;
        }

        public Criteria andBackDateLessThan(Date value) {
            addCriterionForJDBCDate("back_date <", value, "backDate");
            return (Criteria) this;
        }

        public Criteria andBackDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("back_date <=", value, "backDate");
            return (Criteria) this;
        }

        public Criteria andBackDateIn(List<Date> values) {
            addCriterionForJDBCDate("back_date in", values, "backDate");
            return (Criteria) this;
        }

        public Criteria andBackDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("back_date not in", values, "backDate");
            return (Criteria) this;
        }

        public Criteria andBackDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("back_date between", value1, value2, "backDate");
            return (Criteria) this;
        }

        public Criteria andBackDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("back_date not between", value1, value2, "backDate");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusIsNull() {
            addCriterion("royalty_status is null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusIsNotNull() {
            addCriterion("royalty_status is not null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusEqualTo(Integer value) {
            addCriterion("royalty_status =", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusNotEqualTo(Integer value) {
            addCriterion("royalty_status <>", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusGreaterThan(Integer value) {
            addCriterion("royalty_status >", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("royalty_status >=", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusLessThan(Integer value) {
            addCriterion("royalty_status <", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusLessThanOrEqualTo(Integer value) {
            addCriterion("royalty_status <=", value, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusIn(List<Integer> values) {
            addCriterion("royalty_status in", values, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusNotIn(List<Integer> values) {
            addCriterion("royalty_status not in", values, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusBetween(Integer value1, Integer value2) {
            addCriterion("royalty_status between", value1, value2, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("royalty_status not between", value1, value2, "royaltyStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyIsNull() {
            addCriterion("royalty_money is null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyIsNotNull() {
            addCriterion("royalty_money is not null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyEqualTo(BigDecimal value) {
            addCriterion("royalty_money =", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyNotEqualTo(BigDecimal value) {
            addCriterion("royalty_money <>", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyGreaterThan(BigDecimal value) {
            addCriterion("royalty_money >", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("royalty_money >=", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyLessThan(BigDecimal value) {
            addCriterion("royalty_money <", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("royalty_money <=", value, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyIn(List<BigDecimal> values) {
            addCriterion("royalty_money in", values, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyNotIn(List<BigDecimal> values) {
            addCriterion("royalty_money not in", values, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("royalty_money between", value1, value2, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("royalty_money not between", value1, value2, "royaltyMoney");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeIsNull() {
            addCriterion("royalty_record_time is null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeIsNotNull() {
            addCriterion("royalty_record_time is not null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeEqualTo(Date value) {
            addCriterion("royalty_record_time =", value, "royaltyRecordTime");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeNotEqualTo(Date value) {
            addCriterion("royalty_record_time <>", value, "royaltyRecordTime");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeGreaterThan(Date value) {
            addCriterion("royalty_record_time >", value, "royaltyRecordTime");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("royalty_record_time >=", value, "royaltyRecordTime");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeLessThan(Date value) {
            addCriterion("royalty_record_time <", value, "royaltyRecordTime");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeLessThanOrEqualTo(Date value) {
            addCriterion("royalty_record_time <=", value, "royaltyRecordTime");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeIn(List<Date> values) {
            addCriterion("royalty_record_time in", values, "royaltyRecordTime");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeNotIn(List<Date> values) {
            addCriterion("royalty_record_time not in", values, "royaltyRecordTime");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeBetween(Date value1, Date value2) {
            addCriterion("royalty_record_time between", value1, value2, "royaltyRecordTime");
            return (Criteria) this;
        }

        public Criteria andRoyaltyRecordTimeNotBetween(Date value1, Date value2) {
            addCriterion("royalty_record_time not between", value1, value2, "royaltyRecordTime");
            return (Criteria) this;
        }

        public Criteria andIsAbolishIsNull() {
            addCriterion("is_abolish is null");
            return (Criteria) this;
        }

        public Criteria andIsAbolishIsNotNull() {
            addCriterion("is_abolish is not null");
            return (Criteria) this;
        }

        public Criteria andIsAbolishEqualTo(Integer value) {
            addCriterion("is_abolish =", value, "isAbolish");
            return (Criteria) this;
        }

        public Criteria andIsAbolishNotEqualTo(Integer value) {
            addCriterion("is_abolish <>", value, "isAbolish");
            return (Criteria) this;
        }

        public Criteria andIsAbolishGreaterThan(Integer value) {
            addCriterion("is_abolish >", value, "isAbolish");
            return (Criteria) this;
        }

        public Criteria andIsAbolishGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_abolish >=", value, "isAbolish");
            return (Criteria) this;
        }

        public Criteria andIsAbolishLessThan(Integer value) {
            addCriterion("is_abolish <", value, "isAbolish");
            return (Criteria) this;
        }

        public Criteria andIsAbolishLessThanOrEqualTo(Integer value) {
            addCriterion("is_abolish <=", value, "isAbolish");
            return (Criteria) this;
        }

        public Criteria andIsAbolishIn(List<Integer> values) {
            addCriterion("is_abolish in", values, "isAbolish");
            return (Criteria) this;
        }

        public Criteria andIsAbolishNotIn(List<Integer> values) {
            addCriterion("is_abolish not in", values, "isAbolish");
            return (Criteria) this;
        }

        public Criteria andIsAbolishBetween(Integer value1, Integer value2) {
            addCriterion("is_abolish between", value1, value2, "isAbolish");
            return (Criteria) this;
        }

        public Criteria andIsAbolishNotBetween(Integer value1, Integer value2) {
            addCriterion("is_abolish not between", value1, value2, "isAbolish");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("source like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("source not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("source not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andContractIdIsNull() {
            addCriterion("contract_id is null");
            return (Criteria) this;
        }

        public Criteria andContractIdIsNotNull() {
            addCriterion("contract_id is not null");
            return (Criteria) this;
        }

        public Criteria andContractIdEqualTo(String value) {
            addCriterion("contract_id =", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotEqualTo(String value) {
            addCriterion("contract_id <>", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdGreaterThan(String value) {
            addCriterion("contract_id >", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdGreaterThanOrEqualTo(String value) {
            addCriterion("contract_id >=", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdLessThan(String value) {
            addCriterion("contract_id <", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdLessThanOrEqualTo(String value) {
            addCriterion("contract_id <=", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdLike(String value) {
            addCriterion("contract_id like", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotLike(String value) {
            addCriterion("contract_id not like", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdIn(List<String> values) {
            addCriterion("contract_id in", values, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotIn(List<String> values) {
            addCriterion("contract_id not in", values, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdBetween(String value1, String value2) {
            addCriterion("contract_id between", value1, value2, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotBetween(String value1, String value2) {
            addCriterion("contract_id not between", value1, value2, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNull() {
            addCriterion("contract_number is null");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNotNull() {
            addCriterion("contract_number is not null");
            return (Criteria) this;
        }

        public Criteria andContractNumberEqualTo(String value) {
            addCriterion("contract_number =", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotEqualTo(String value) {
            addCriterion("contract_number <>", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThan(String value) {
            addCriterion("contract_number >", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThanOrEqualTo(String value) {
            addCriterion("contract_number >=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThan(String value) {
            addCriterion("contract_number <", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThanOrEqualTo(String value) {
            addCriterion("contract_number <=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLike(String value) {
            addCriterion("contract_number like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotLike(String value) {
            addCriterion("contract_number not like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberIn(List<String> values) {
            addCriterion("contract_number in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotIn(List<String> values) {
            addCriterion("contract_number not in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberBetween(String value1, String value2) {
            addCriterion("contract_number between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotBetween(String value1, String value2) {
            addCriterion("contract_number not between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNull() {
            addCriterion("customer_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNotNull() {
            addCriterion("customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdEqualTo(String value) {
            addCriterion("customer_id =", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotEqualTo(String value) {
            addCriterion("customer_id <>", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThan(String value) {
            addCriterion("customer_id >", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("customer_id >=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThan(String value) {
            addCriterion("customer_id <", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("customer_id <=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLike(String value) {
            addCriterion("customer_id like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotLike(String value) {
            addCriterion("customer_id not like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIn(List<String> values) {
            addCriterion("customer_id in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotIn(List<String> values) {
            addCriterion("customer_id not in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdBetween(String value1, String value2) {
            addCriterion("customer_id between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotBetween(String value1, String value2) {
            addCriterion("customer_id not between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("customer_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("customer_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("customer_name =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("customer_name <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("customer_name >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_name >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("customer_name <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("customer_name <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("customer_name like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("customer_name not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("customer_name in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("customer_name not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("customer_name between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("customer_name not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(String value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(String value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(String value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(String value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(String value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLike(String value) {
            addCriterion("order_id like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotLike(String value) {
            addCriterion("order_id not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<String> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<String> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(String value1, String value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(String value1, String value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIsNull() {
            addCriterion("order_number is null");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIsNotNull() {
            addCriterion("order_number is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNumberEqualTo(String value) {
            addCriterion("order_number =", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotEqualTo(String value) {
            addCriterion("order_number <>", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThan(String value) {
            addCriterion("order_number >", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThanOrEqualTo(String value) {
            addCriterion("order_number >=", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThan(String value) {
            addCriterion("order_number <", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThanOrEqualTo(String value) {
            addCriterion("order_number <=", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLike(String value) {
            addCriterion("order_number like", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotLike(String value) {
            addCriterion("order_number not like", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIn(List<String> values) {
            addCriterion("order_number in", values, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotIn(List<String> values) {
            addCriterion("order_number not in", values, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberBetween(String value1, String value2) {
            addCriterion("order_number between", value1, value2, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotBetween(String value1, String value2) {
            addCriterion("order_number not between", value1, value2, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdIsNull() {
            addCriterion("salesman_id is null");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdIsNotNull() {
            addCriterion("salesman_id is not null");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdEqualTo(String value) {
            addCriterion("salesman_id =", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdNotEqualTo(String value) {
            addCriterion("salesman_id <>", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdGreaterThan(String value) {
            addCriterion("salesman_id >", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdGreaterThanOrEqualTo(String value) {
            addCriterion("salesman_id >=", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdLessThan(String value) {
            addCriterion("salesman_id <", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdLessThanOrEqualTo(String value) {
            addCriterion("salesman_id <=", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdLike(String value) {
            addCriterion("salesman_id like", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdNotLike(String value) {
            addCriterion("salesman_id not like", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdIn(List<String> values) {
            addCriterion("salesman_id in", values, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdNotIn(List<String> values) {
            addCriterion("salesman_id not in", values, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdBetween(String value1, String value2) {
            addCriterion("salesman_id between", value1, value2, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdNotBetween(String value1, String value2) {
            addCriterion("salesman_id not between", value1, value2, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdIsNull() {
            addCriterion("filiale_id is null");
            return (Criteria) this;
        }

        public Criteria andFilialeIdIsNotNull() {
            addCriterion("filiale_id is not null");
            return (Criteria) this;
        }

        public Criteria andFilialeIdEqualTo(String value) {
            addCriterion("filiale_id =", value, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdNotEqualTo(String value) {
            addCriterion("filiale_id <>", value, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdGreaterThan(String value) {
            addCriterion("filiale_id >", value, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdGreaterThanOrEqualTo(String value) {
            addCriterion("filiale_id >=", value, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdLessThan(String value) {
            addCriterion("filiale_id <", value, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdLessThanOrEqualTo(String value) {
            addCriterion("filiale_id <=", value, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdLike(String value) {
            addCriterion("filiale_id like", value, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdNotLike(String value) {
            addCriterion("filiale_id not like", value, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdIn(List<String> values) {
            addCriterion("filiale_id in", values, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdNotIn(List<String> values) {
            addCriterion("filiale_id not in", values, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdBetween(String value1, String value2) {
            addCriterion("filiale_id between", value1, value2, "filialeId");
            return (Criteria) this;
        }

        public Criteria andFilialeIdNotBetween(String value1, String value2) {
            addCriterion("filiale_id not between", value1, value2, "filialeId");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusIsNull() {
            addCriterion("invoice_status is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusIsNotNull() {
            addCriterion("invoice_status is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusEqualTo(Integer value) {
            addCriterion("invoice_status =", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusNotEqualTo(Integer value) {
            addCriterion("invoice_status <>", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusGreaterThan(Integer value) {
            addCriterion("invoice_status >", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_status >=", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusLessThan(Integer value) {
            addCriterion("invoice_status <", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_status <=", value, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusIn(List<Integer> values) {
            addCriterion("invoice_status in", values, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusNotIn(List<Integer> values) {
            addCriterion("invoice_status not in", values, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusBetween(Integer value1, Integer value2) {
            addCriterion("invoice_status between", value1, value2, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andInvoiceStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_status not between", value1, value2, "invoiceStatus");
            return (Criteria) this;
        }

        public Criteria andIsCheckIsNull() {
            addCriterion("is_check is null");
            return (Criteria) this;
        }

        public Criteria andIsCheckIsNotNull() {
            addCriterion("is_check is not null");
            return (Criteria) this;
        }

        public Criteria andIsCheckEqualTo(Integer value) {
            addCriterion("is_check =", value, "isCheck");
            return (Criteria) this;
        }

        public Criteria andIsCheckNotEqualTo(Integer value) {
            addCriterion("is_check <>", value, "isCheck");
            return (Criteria) this;
        }

        public Criteria andIsCheckGreaterThan(Integer value) {
            addCriterion("is_check >", value, "isCheck");
            return (Criteria) this;
        }

        public Criteria andIsCheckGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_check >=", value, "isCheck");
            return (Criteria) this;
        }

        public Criteria andIsCheckLessThan(Integer value) {
            addCriterion("is_check <", value, "isCheck");
            return (Criteria) this;
        }

        public Criteria andIsCheckLessThanOrEqualTo(Integer value) {
            addCriterion("is_check <=", value, "isCheck");
            return (Criteria) this;
        }

        public Criteria andIsCheckIn(List<Integer> values) {
            addCriterion("is_check in", values, "isCheck");
            return (Criteria) this;
        }

        public Criteria andIsCheckNotIn(List<Integer> values) {
            addCriterion("is_check not in", values, "isCheck");
            return (Criteria) this;
        }

        public Criteria andIsCheckBetween(Integer value1, Integer value2) {
            addCriterion("is_check between", value1, value2, "isCheck");
            return (Criteria) this;
        }

        public Criteria andIsCheckNotBetween(Integer value1, Integer value2) {
            addCriterion("is_check not between", value1, value2, "isCheck");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andCloseStatusIsNull() {
            addCriterion("close_status is null");
            return (Criteria) this;
        }

        public Criteria andCloseStatusIsNotNull() {
            addCriterion("close_status is not null");
            return (Criteria) this;
        }

        public Criteria andCloseStatusEqualTo(Integer value) {
            addCriterion("close_status =", value, "closeStatus");
            return (Criteria) this;
        }

        public Criteria andCloseStatusNotEqualTo(Integer value) {
            addCriterion("close_status <>", value, "closeStatus");
            return (Criteria) this;
        }

        public Criteria andCloseStatusGreaterThan(Integer value) {
            addCriterion("close_status >", value, "closeStatus");
            return (Criteria) this;
        }

        public Criteria andCloseStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("close_status >=", value, "closeStatus");
            return (Criteria) this;
        }

        public Criteria andCloseStatusLessThan(Integer value) {
            addCriterion("close_status <", value, "closeStatus");
            return (Criteria) this;
        }

        public Criteria andCloseStatusLessThanOrEqualTo(Integer value) {
            addCriterion("close_status <=", value, "closeStatus");
            return (Criteria) this;
        }

        public Criteria andCloseStatusIn(List<Integer> values) {
            addCriterion("close_status in", values, "closeStatus");
            return (Criteria) this;
        }

        public Criteria andCloseStatusNotIn(List<Integer> values) {
            addCriterion("close_status not in", values, "closeStatus");
            return (Criteria) this;
        }

        public Criteria andCloseStatusBetween(Integer value1, Integer value2) {
            addCriterion("close_status between", value1, value2, "closeStatus");
            return (Criteria) this;
        }

        public Criteria andCloseStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("close_status not between", value1, value2, "closeStatus");
            return (Criteria) this;
        }

        public Criteria andShiftTypeIsNull() {
            addCriterion("shift_type is null");
            return (Criteria) this;
        }

        public Criteria andShiftTypeIsNotNull() {
            addCriterion("shift_type is not null");
            return (Criteria) this;
        }

        public Criteria andShiftTypeEqualTo(Integer value) {
            addCriterion("shift_type =", value, "shiftType");
            return (Criteria) this;
        }

        public Criteria andShiftTypeNotEqualTo(Integer value) {
            addCriterion("shift_type <>", value, "shiftType");
            return (Criteria) this;
        }

        public Criteria andShiftTypeGreaterThan(Integer value) {
            addCriterion("shift_type >", value, "shiftType");
            return (Criteria) this;
        }

        public Criteria andShiftTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("shift_type >=", value, "shiftType");
            return (Criteria) this;
        }

        public Criteria andShiftTypeLessThan(Integer value) {
            addCriterion("shift_type <", value, "shiftType");
            return (Criteria) this;
        }

        public Criteria andShiftTypeLessThanOrEqualTo(Integer value) {
            addCriterion("shift_type <=", value, "shiftType");
            return (Criteria) this;
        }

        public Criteria andShiftTypeIn(List<Integer> values) {
            addCriterion("shift_type in", values, "shiftType");
            return (Criteria) this;
        }

        public Criteria andShiftTypeNotIn(List<Integer> values) {
            addCriterion("shift_type not in", values, "shiftType");
            return (Criteria) this;
        }

        public Criteria andShiftTypeBetween(Integer value1, Integer value2) {
            addCriterion("shift_type between", value1, value2, "shiftType");
            return (Criteria) this;
        }

        public Criteria andShiftTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("shift_type not between", value1, value2, "shiftType");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdIsNull() {
            addCriterion("shift_return_money_id is null");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdIsNotNull() {
            addCriterion("shift_return_money_id is not null");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdEqualTo(String value) {
            addCriterion("shift_return_money_id =", value, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdNotEqualTo(String value) {
            addCriterion("shift_return_money_id <>", value, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdGreaterThan(String value) {
            addCriterion("shift_return_money_id >", value, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdGreaterThanOrEqualTo(String value) {
            addCriterion("shift_return_money_id >=", value, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdLessThan(String value) {
            addCriterion("shift_return_money_id <", value, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdLessThanOrEqualTo(String value) {
            addCriterion("shift_return_money_id <=", value, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdLike(String value) {
            addCriterion("shift_return_money_id like", value, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdNotLike(String value) {
            addCriterion("shift_return_money_id not like", value, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdIn(List<String> values) {
            addCriterion("shift_return_money_id in", values, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdNotIn(List<String> values) {
            addCriterion("shift_return_money_id not in", values, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdBetween(String value1, String value2) {
            addCriterion("shift_return_money_id between", value1, value2, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftReturnMoneyIdNotBetween(String value1, String value2) {
            addCriterion("shift_return_money_id not between", value1, value2, "shiftReturnMoneyId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdIsNull() {
            addCriterion("shift_order_id is null");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdIsNotNull() {
            addCriterion("shift_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdEqualTo(String value) {
            addCriterion("shift_order_id =", value, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdNotEqualTo(String value) {
            addCriterion("shift_order_id <>", value, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdGreaterThan(String value) {
            addCriterion("shift_order_id >", value, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("shift_order_id >=", value, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdLessThan(String value) {
            addCriterion("shift_order_id <", value, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdLessThanOrEqualTo(String value) {
            addCriterion("shift_order_id <=", value, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdLike(String value) {
            addCriterion("shift_order_id like", value, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdNotLike(String value) {
            addCriterion("shift_order_id not like", value, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdIn(List<String> values) {
            addCriterion("shift_order_id in", values, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdNotIn(List<String> values) {
            addCriterion("shift_order_id not in", values, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdBetween(String value1, String value2) {
            addCriterion("shift_order_id between", value1, value2, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andShiftOrderIdNotBetween(String value1, String value2) {
            addCriterion("shift_order_id not between", value1, value2, "shiftOrderId");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("create_by is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("create_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(String value) {
            addCriterion("create_by =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(String value) {
            addCriterion("create_by <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(String value) {
            addCriterion("create_by >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(String value) {
            addCriterion("create_by >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(String value) {
            addCriterion("create_by <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(String value) {
            addCriterion("create_by <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLike(String value) {
            addCriterion("create_by like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotLike(String value) {
            addCriterion("create_by not like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<String> values) {
            addCriterion("create_by in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<String> values) {
            addCriterion("create_by not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(String value1, String value2) {
            addCriterion("create_by between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(String value1, String value2) {
            addCriterion("create_by not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNull() {
            addCriterion("create_tm is null");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNotNull() {
            addCriterion("create_tm is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTmEqualTo(Date value) {
            addCriterion("create_tm =", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotEqualTo(Date value) {
            addCriterion("create_tm <>", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThan(Date value) {
            addCriterion("create_tm >", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("create_tm >=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThan(Date value) {
            addCriterion("create_tm <", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThanOrEqualTo(Date value) {
            addCriterion("create_tm <=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmIn(List<Date> values) {
            addCriterion("create_tm in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotIn(List<Date> values) {
            addCriterion("create_tm not in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmBetween(Date value1, Date value2) {
            addCriterion("create_tm between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotBetween(Date value1, Date value2) {
            addCriterion("create_tm not between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("update_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("update_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(String value) {
            addCriterion("update_by =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(String value) {
            addCriterion("update_by <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(String value) {
            addCriterion("update_by >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(String value) {
            addCriterion("update_by >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(String value) {
            addCriterion("update_by <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(String value) {
            addCriterion("update_by <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLike(String value) {
            addCriterion("update_by like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotLike(String value) {
            addCriterion("update_by not like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<String> values) {
            addCriterion("update_by in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<String> values) {
            addCriterion("update_by not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(String value1, String value2) {
            addCriterion("update_by between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(String value1, String value2) {
            addCriterion("update_by not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNull() {
            addCriterion("update_tm is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNotNull() {
            addCriterion("update_tm is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmEqualTo(Date value) {
            addCriterion("update_tm =", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotEqualTo(Date value) {
            addCriterion("update_tm <>", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThan(Date value) {
            addCriterion("update_tm >", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("update_tm >=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThan(Date value) {
            addCriterion("update_tm <", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThanOrEqualTo(Date value) {
            addCriterion("update_tm <=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIn(List<Date> values) {
            addCriterion("update_tm in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotIn(List<Date> values) {
            addCriterion("update_tm not in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmBetween(Date value1, Date value2) {
            addCriterion("update_tm between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotBetween(Date value1, Date value2) {
            addCriterion("update_tm not between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andDelFlagIsNull() {
            addCriterion("del_flag is null");
            return (Criteria) this;
        }

        public Criteria andDelFlagIsNotNull() {
            addCriterion("del_flag is not null");
            return (Criteria) this;
        }

        public Criteria andDelFlagEqualTo(Integer value) {
            addCriterion("del_flag =", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotEqualTo(Integer value) {
            addCriterion("del_flag <>", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagGreaterThan(Integer value) {
            addCriterion("del_flag >", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("del_flag >=", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagLessThan(Integer value) {
            addCriterion("del_flag <", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagLessThanOrEqualTo(Integer value) {
            addCriterion("del_flag <=", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagIn(List<Integer> values) {
            addCriterion("del_flag in", values, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotIn(List<Integer> values) {
            addCriterion("del_flag not in", values, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagBetween(Integer value1, Integer value2) {
            addCriterion("del_flag between", value1, value2, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("del_flag not between", value1, value2, "delFlag");
            return (Criteria) this;
        }

        public Criteria andExamStateIsNull() {
            addCriterion("exam_state is null");
            return (Criteria) this;
        }

        public Criteria andExamStateIsNotNull() {
            addCriterion("exam_state is not null");
            return (Criteria) this;
        }

        public Criteria andExamStateEqualTo(Integer value) {
            addCriterion("exam_state =", value, "examState");
            return (Criteria) this;
        }

        public Criteria andExamStateNotEqualTo(Integer value) {
            addCriterion("exam_state <>", value, "examState");
            return (Criteria) this;
        }

        public Criteria andExamStateGreaterThan(Integer value) {
            addCriterion("exam_state >", value, "examState");
            return (Criteria) this;
        }

        public Criteria andExamStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("exam_state >=", value, "examState");
            return (Criteria) this;
        }

        public Criteria andExamStateLessThan(Integer value) {
            addCriterion("exam_state <", value, "examState");
            return (Criteria) this;
        }

        public Criteria andExamStateLessThanOrEqualTo(Integer value) {
            addCriterion("exam_state <=", value, "examState");
            return (Criteria) this;
        }

        public Criteria andExamStateIn(List<Integer> values) {
            addCriterion("exam_state in", values, "examState");
            return (Criteria) this;
        }

        public Criteria andExamStateNotIn(List<Integer> values) {
            addCriterion("exam_state not in", values, "examState");
            return (Criteria) this;
        }

        public Criteria andExamStateBetween(Integer value1, Integer value2) {
            addCriterion("exam_state between", value1, value2, "examState");
            return (Criteria) this;
        }

        public Criteria andExamStateNotBetween(Integer value1, Integer value2) {
            addCriterion("exam_state not between", value1, value2, "examState");
            return (Criteria) this;
        }

        public Criteria andReturnStatusIsNull() {
            addCriterion("return_status is null");
            return (Criteria) this;
        }

        public Criteria andReturnStatusIsNotNull() {
            addCriterion("return_status is not null");
            return (Criteria) this;
        }

        public Criteria andReturnStatusEqualTo(Integer value) {
            addCriterion("return_status =", value, "returnStatus");
            return (Criteria) this;
        }

        public Criteria andReturnStatusNotEqualTo(Integer value) {
            addCriterion("return_status <>", value, "returnStatus");
            return (Criteria) this;
        }

        public Criteria andReturnStatusGreaterThan(Integer value) {
            addCriterion("return_status >", value, "returnStatus");
            return (Criteria) this;
        }

        public Criteria andReturnStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("return_status >=", value, "returnStatus");
            return (Criteria) this;
        }

        public Criteria andReturnStatusLessThan(Integer value) {
            addCriterion("return_status <", value, "returnStatus");
            return (Criteria) this;
        }

        public Criteria andReturnStatusLessThanOrEqualTo(Integer value) {
            addCriterion("return_status <=", value, "returnStatus");
            return (Criteria) this;
        }

        public Criteria andReturnStatusIn(List<Integer> values) {
            addCriterion("return_status in", values, "returnStatus");
            return (Criteria) this;
        }

        public Criteria andReturnStatusNotIn(List<Integer> values) {
            addCriterion("return_status not in", values, "returnStatus");
            return (Criteria) this;
        }

        public Criteria andReturnStatusBetween(Integer value1, Integer value2) {
            addCriterion("return_status between", value1, value2, "returnStatus");
            return (Criteria) this;
        }

        public Criteria andReturnStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("return_status not between", value1, value2, "returnStatus");
            return (Criteria) this;
        }

        public Criteria andDataSourceIsNull() {
            addCriterion("data_source is null");
            return (Criteria) this;
        }

        public Criteria andDataSourceIsNotNull() {
            addCriterion("data_source is not null");
            return (Criteria) this;
        }

        public Criteria andDataSourceEqualTo(Integer value) {
            addCriterion("data_source =", value, "dataSource");
            return (Criteria) this;
        }

        public Criteria andDataSourceNotEqualTo(Integer value) {
            addCriterion("data_source <>", value, "dataSource");
            return (Criteria) this;
        }

        public Criteria andDataSourceGreaterThan(Integer value) {
            addCriterion("data_source >", value, "dataSource");
            return (Criteria) this;
        }

        public Criteria andDataSourceGreaterThanOrEqualTo(Integer value) {
            addCriterion("data_source >=", value, "dataSource");
            return (Criteria) this;
        }

        public Criteria andDataSourceLessThan(Integer value) {
            addCriterion("data_source <", value, "dataSource");
            return (Criteria) this;
        }

        public Criteria andDataSourceLessThanOrEqualTo(Integer value) {
            addCriterion("data_source <=", value, "dataSource");
            return (Criteria) this;
        }

        public Criteria andDataSourceIn(List<Integer> values) {
            addCriterion("data_source in", values, "dataSource");
            return (Criteria) this;
        }

        public Criteria andDataSourceNotIn(List<Integer> values) {
            addCriterion("data_source not in", values, "dataSource");
            return (Criteria) this;
        }

        public Criteria andDataSourceBetween(Integer value1, Integer value2) {
            addCriterion("data_source between", value1, value2, "dataSource");
            return (Criteria) this;
        }

        public Criteria andDataSourceNotBetween(Integer value1, Integer value2) {
            addCriterion("data_source not between", value1, value2, "dataSource");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataIsNull() {
            addCriterion("member_error_data is null");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataIsNotNull() {
            addCriterion("member_error_data is not null");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataEqualTo(Integer value) {
            addCriterion("member_error_data =", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataNotEqualTo(Integer value) {
            addCriterion("member_error_data <>", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataGreaterThan(Integer value) {
            addCriterion("member_error_data >", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataGreaterThanOrEqualTo(Integer value) {
            addCriterion("member_error_data >=", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataLessThan(Integer value) {
            addCriterion("member_error_data <", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataLessThanOrEqualTo(Integer value) {
            addCriterion("member_error_data <=", value, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataIn(List<Integer> values) {
            addCriterion("member_error_data in", values, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataNotIn(List<Integer> values) {
            addCriterion("member_error_data not in", values, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataBetween(Integer value1, Integer value2) {
            addCriterion("member_error_data between", value1, value2, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMemberErrorDataNotBetween(Integer value1, Integer value2) {
            addCriterion("member_error_data not between", value1, value2, "memberErrorData");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusIsNull() {
            addCriterion("maintain_status is null");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusIsNotNull() {
            addCriterion("maintain_status is not null");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusEqualTo(Integer value) {
            addCriterion("maintain_status =", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusNotEqualTo(Integer value) {
            addCriterion("maintain_status <>", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusGreaterThan(Integer value) {
            addCriterion("maintain_status >", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("maintain_status >=", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusLessThan(Integer value) {
            addCriterion("maintain_status <", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusLessThanOrEqualTo(Integer value) {
            addCriterion("maintain_status <=", value, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusIn(List<Integer> values) {
            addCriterion("maintain_status in", values, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusNotIn(List<Integer> values) {
            addCriterion("maintain_status not in", values, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusBetween(Integer value1, Integer value2) {
            addCriterion("maintain_status between", value1, value2, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andMaintainStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("maintain_status not between", value1, value2, "maintainStatus");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkIsNull() {
            addCriterion("royalty_mark is null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkIsNotNull() {
            addCriterion("royalty_mark is not null");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkEqualTo(String value) {
            addCriterion("royalty_mark =", value, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkNotEqualTo(String value) {
            addCriterion("royalty_mark <>", value, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkGreaterThan(String value) {
            addCriterion("royalty_mark >", value, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkGreaterThanOrEqualTo(String value) {
            addCriterion("royalty_mark >=", value, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkLessThan(String value) {
            addCriterion("royalty_mark <", value, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkLessThanOrEqualTo(String value) {
            addCriterion("royalty_mark <=", value, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkLike(String value) {
            addCriterion("royalty_mark like", value, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkNotLike(String value) {
            addCriterion("royalty_mark not like", value, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkIn(List<String> values) {
            addCriterion("royalty_mark in", values, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkNotIn(List<String> values) {
            addCriterion("royalty_mark not in", values, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkBetween(String value1, String value2) {
            addCriterion("royalty_mark between", value1, value2, "royaltyMark");
            return (Criteria) this;
        }

        public Criteria andRoyaltyMarkNotBetween(String value1, String value2) {
            addCriterion("royalty_mark not between", value1, value2, "royaltyMark");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}